Trying to access a Excel Spreadsheet using the Data Link Properties Dialog, and then choosing:
next>
Test4442 ODBC Connection made in Configuration Settings, Systeembeheer, Gegevenbronnen (ODBC)
and then using the Connection string for an OleDbConnection
OleDbConnection OleDbCon = new OleDbConnection();
OleDbCon.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data
Source=TEST4442"
gave this errormessage:
In INFO: OLE DB .NET Managed Provider Does Not Support Some OLE DB Providers in Visual C# .NET Microsoft says:
But in ODBC .NET Data Provider they say:
The ODBC .NET Data Provider is an add-on component to the .NET Framework. It
provides access to native ODBC drivers the same way the OLE DB .NET Data
Provider provides access to native OLE DB providers. The ODBC .NET Data Provider
is intended to work with all compliant ODBC drivers but only the
following drivers have been tested with the ODBC .NET Data Provider:
Microsoft SQL ODBC Driver
Microsoft ODBC Driver for Oracle
Microsoft Jet ODBC Driver
So they recommend to use an untested driver????
Isn't ODBC a bit old anyway?
Would it be better to use the Jet OLE DB Provider? It seems to be supported:
See also:
OLE DB Providers Overview (reference to Microsoft Jet)
MDAC 2.8 Deprecated Components (ODBC Provider (MSDASQL))
DownloadPage MDAC 2.8 says: This release does not include Microsoft Jet
Informatie over Jet 4.0 Service Pack 8
De meest recente service pack voor de Microsoft Jet 4.0-database-engine ophalen